2013-04-04 - 5910.200 - Rel Notes - Contracts - Release 016 #BIReleases2013

Release Notes:

‍5910.200 - Contracts - EPM199

‍

Admin Info

Purpose
 Including Contract Information in EPM199 - Scorecard by Region
Release No
 016
Submitted
 04-04-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Praveen Guntuka
Object(s) Tested By
 Praveen Guntuka

‍Report Name

EPM199 - Scorecard by Region

‍BEx Query

ZMP_OPASA_Q001
ZMP_OPASA_Q002
ZMP_OPASA_Q003
ZMP_OPASA_Q004
ZMP_OPASA_Q005
ZMP_OPASA_Q006
ZMP_OPASA_Q007
ZMP_OPASA_Q008
ZMP_OPASA_Q009
ZMP_OPASA_Q010
ZMP_OPASA_Q011
ZMP_OPASA_Q012

‍NEC Crystal Reports Standards Check

1. EPM199 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. EPM199 NEC CR checklist has been sent to NEC and also attached here for reference:
EPM199 NEC CR Standard Check List.xlsx

Summary Level Check

‍Test Conducted

Grouping : North America
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 65,895,547
 65,895,547.15
 Pass
2
 Last Year Shipped YTD
 49,535,432
 49,535,431.60
 Pass
3
 Current Year Budget YTD
 81,480,846
 81,480,846
 Pass
4
 Total Open Revenue
 128,132,426
 128,132,425.56
 Pass
5
 Total Shipped Current Year
 194,027,973
 194,027,972.71
 Pass
6
 Total Shipped Last Year
 447,596,836
 447,596,835.97
 Pass
7
 Total Budget Current Year
 516,707,703
 516,707,703
 Pass
8
 TY Quantity
 5,913,844
 5,913,844
 Pass
9
 LY Quantity
 4,735,464
 4,735,464
 Pass
10
 Budget Quantity
 0
 0
 Pass

Grouping : EMEA
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 10,332,854
 10,332,854.10
 Pass
2
 Last Year Shipped YTD
 7,021,306
 7,021,306.16
 Pass
3
 Current Year Budget YTD
 10,625,743
 10,625,743
 Pass
4
 Total Open Revenue
 22,352,448
 22,352,447.79
 Pass
5
 Total Shipped Current Year
 32,685,302
 32,685,301.89
 Pass
6
 Total Shipped Last Year
 61,654,111
 61,654,111.48
 Pass
7
 Total Budget Current Year
 75,557,744
 75,557,744
 Pass
8
 TY Quantity
 838,528
 838,528
 Pass
9
 LY Quantity
 595,911
 595,911
 Pass
10
 Budget Quantity
 0
 0
 Pass

Grouping : Emerging Markets
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 3,643,283
 3,643,282.92
 Pass
2
 Last Year Shipped YTD
 1,586,184
 1,586,183.67
 Pass
3
 Current Year Budget YTD
 3,668,082
 3,668,082
 Pass
4
 Total Open Revenue
 9,728,361
 9,728,360.93
 Pass
5
 Total Shipped Current Year
 13,371,644
 13,371,643.85
 Pass
6
 Total Shipped Last Year
 19,091,204
 19,091,204.07
 Pass
7
 Total Budget Current Year
 25,420,290
 25,420,290
 Pass
8
 TY Quantity
 227,612
 227,612
 Pass
9
 LY Quantity
 114,812
 114,812
 Pass
10
 Budget Quantity
 0
 0
 Pass

Grouping : North America - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped MTD
 42,158,008
 42,158,008.39
 Pass
2
 Last Year Shipped MTD
 34,323,003
 34,323,003.42
 Pass
3
 Current Year Budget MTD
 55,716,766
 55,716,766
 Pass
4
 TY Quantity
 3,649,036
 3,649,036
 Pass
5
 LY Quantity
 3,201,655
 3,201,655
 Pass
6
 Budget Quantity
 0
 0
 Pass

Grouping : EMEA - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped MTD
 5,371,593
 5,371,593.44
 Pass
2
 Last Year Shipped MTD
 5,247,140
 5,247,139.94
 Pass
3
 Current Year Budget MTD
 5,404,789
 5,404,789
 Pass
4
 TY Quantity
 380,010
 380,010
 Pass
5
 LY Quantity
 433,737
 433,737
 Pass
6
 Budget Quantity
 0
 0
 Pass

Grouping : Emerging Market - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped MTD
 2,035,659
 2,035,658.87
 Pass
2
 Last Year Shipped MTD
 758,492
 758,491.72
 Pass
3
 Current Year Budget MTD
 2,338,531
 2,338,531
 Pass
4
 TY Quantity
 118,573
 118,573
 Pass
5
 LY Quantity
 56,239
 56,239
 Pass
6
 Budget Quantity
 0
 0
 Pass

Product Mix Sub Report Validation

‍Test Conducted

Grouping: North America > Headwear
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 58,189,876
 58,189,876.13
 Pass
2
 Open
 110,926,270
 110,926,270.34
 Pass
3
 Total Revenue YTD
 169,116,146
 169,116,146
 Pass
4
 Last Year Shipped YTD
 49,414,043
 49,414,042.88
 Pass
5
 Current Year Budget YTD
 71,549,289
 71,549,289
 Pass
6
 TY Quantity
 5,072,270
 5,072,270
 Pass
7
 LY Quantity
 4,726,020
 4,726,020
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > Apparel
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 124,501
 124,501.04
 Pass
2
 Open
 754,317
 754,316.55
 Pass
3
 Total Revenue YTD
 878,818
 878,817.59
 Pass
4
 Last Year Shipped YTD
 603,697
 603,696.51
 Pass
5
 Current Year Budget YTD
 333,822
 333,822
 Pass
6
 TY Quantity
 9,733
 9,733
 Pass
7
 LY Quantity
 51,819
 51,819
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > Accessories
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 159,927
 159,926.74
 Pass
2
 Open
 29,351
 29,351.36
 Pass
3
 Total Revenue YTD
 189,278
 189,278.10
 Pass
4
 Last Year Shipped YTD
 14,145
 14,144.90
 Pass
5
 Current Year Budget YTD
 101,836
 101,836
 Pass
6
 TY Quantity
 1,797
 1,797
 Pass
7
 LY Quantity
 1,372
 1,372
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: North America > Accessories - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 152,138
 152,137.70
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 152,138
 152,137.70
 Pass
4
 Last Year Shipped YTD
 47,616
 47,615.94
 Pass
5
 Current Year Budget YTD
 64,700
 64,700
 Pass
6
 TY Quantity
 12,579
 12,579
 Pass
7
 LY Quantity
 4,691
 4,691
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > Headwear - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 5,271,599
 5,271,599.04
 Pass
2
 Open
 12,429
 12,428.99
 Pass
3
 Total Revenue YTD
 5,284,028
 5,284,028.03
 Pass
4
 Last Year Shipped YTD
 4,832,384
 4,832,383.58
 Pass
5
 Current Year Budget YTD
 5,221,694
 5,221,694
 Pass
6
 TY Quantity
 370,919
 370,919
 Pass
7
 LY Quantity
 405,413
 405,413
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > Apparel - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 31,112
 31,112.34
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 31,112
 31,112.34
 Pass
4
 Last Year Shipped YTD
 3,213
 3,213.00
 Pass
5
 Current Year Budget YTD
 16,038
 16,038
 Pass
6
 TY Quantity
 1,708
 1,708
 Pass
7
 LY Quantity
 357
 357
 Pass
8
 Budget Quantity
 0
 0
 Pass

License Sub Report Validation

‍Test Conducted

Grouping: North America > MLB PROPERTIES
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 36,077,617
 36,077,617
 Pass
2
 Open
 40,517,831
 40,517,831
 Pass
3
 Total Revenue YTD
 76,595,448
 76,595,448
 Pass
4
 Last Year Shipped YTD
 30,673,492
 30,673,492
 Pass
5
 Current Year Budget YTD
 41,006,366
 41,006,366
 Pass
6
 TY Quantity
 3,041,465
 3,041,465
 Pass
7
 LY Quantity
 2,539,906
 2,539,906
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > NBA PROPERTIES
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 694,702
 694,702.24
 Pass
2
 Open
 1,133,069
 1,133,069.11
 Pass
3
 Total Revenue YTD
 1,827,771
 1,827,771.35
 Pass
4
 Last Year Shipped YTD
 404,337
 404,337.44
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 41,671
 41,671
 Pass
7
 LY Quantity
 23,341
 23,341
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > MEXICAN BASEBALL LEAGUE
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 138,608
 138,607.71
 Pass
2
 Open
 38,734
 38,733.79
 Pass
3
 Total Revenue YTD
 177,342
 177,341.50
 Pass
4
 Last Year Shipped YTD
 41,163
 41,162.80
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 9,045
 9,045
 Pass
7
 LY Quantity
 3,881
 3,881
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: North America > NFL PROPERTIES - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 4,554,961
 4,554,961
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 4,554,961
 4,554,961
 Pass
4
 Last Year Shipped YTD
 587,086
 587,086
 Pass
5
 Current Year Budget YTD
 13,600,821
 13,600,821
 Pass
6
 TY Quantity
 344,615
 344,615
 Pass
7
 LY Quantity
 96,617
 96,617
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > WARNER BROS - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 247,435
 247,435
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 247,435
 247,435
 Pass
4
 Last Year Shipped YTD
 63,473
 63,473
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 17,996
 17,996
 Pass
7
 LY Quantity
 3,573
 3,573
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > NON LICENSED - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 303,267
 303,267
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 303,267
 303,267
 Pass
4
 Last Year Shipped YTD
 26,164
 26,164
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 9,680
 9,680
 Pass
7
 LY Quantity
 2,243
 2,243
 Pass
8
 Budget Quantity
 0
 0
 Pass

Customer Segment Sub Report Validation

‍Test Conducted

Grouping: North America > TASTEMAKER
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 471,637
 471,636.62
 Pass
2
 Open
 624,915
 624,915.13
 Pass
3
 Total Revenue YTD
 1,096,552
 1,096,551.75
 Pass
4
 Last Year Shipped YTD
 212,261
 212,260.87
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 37,264
 37,264
 Pass
7
 LY Quantity
 15,650
 15,650
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > FAN SPECIALITY
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 613,907
 613,907.01
 Pass
2
 Open
 1,425,967
 1,425,967.32
 Pass
3
 Total Revenue YTD
 2,039,874
 2,039,874.33
 Pass
4
 Last Year Shipped YTD
 423,664
 423,664.01
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 44,125
 44,125
 Pass
7
 LY Quantity
 43,049
 43,049
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > FASHION REG & IND
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 673,620
 673,620.35
 Pass
2
 Open
 1,033,528
 1,033,528
 Pass
3
 Total Revenue YTD
 1,707,149
 1,707,148.75
 Pass
4
 Last Year Shipped YTD
 398,267
 398,266.81
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 40,043
 40,043
 Pass
7
 LY Quantity
 27,288
 27,288
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: North America > GOLDSTAR - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 1,401,306
 1,401,305.96
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 1,401,306
 1,401,305.96
 Pass
4
 Last Year Shipped YTD
 1,629,535
 1,629,534.73
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 106,094
 106,094
 Pass
7
 LY Quantity
 119,117
 119,117
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > NATIONAL KEY ACCOUNTS - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 1,264
 1,263.94
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 1,264
 1,263.94
 Pass
4
 Last Year Shipped YTD
 2,134
 2,133.90
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 66
 66
 Pass
7
 LY Quantity
 114
 114
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > CLUB/MASS/DISCOUNT - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 70,916
 70,915.92
 Pass
2
 Open
 78
 78.19
 Pass
3
 Total Revenue YTD
 70,994
 70,994.41
 Pass
4
 Last Year Shipped YTD
 344
 344.44
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 3,654
 3,654
 Pass
7
 LY Quantity
 14
 14
 Pass
8
 Budget Quantity
 0
 0
 Pass

Customer Sub Report Validation

‍Test Conducted

Grouping: North America > LIDS INC
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 15,119,373
 15,119,372.51
 Pass
2
 Open
 29,235,553
 29,235,552.93
 Pass
3
 Total Revenue YTD
 44,354,925
 44,354,925.44
 Pass
4
 Last Year Shipped YTD
 11,489,793
 11,489,792.63
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 1,202,231
 1,202,231
 Pass
7
 LY Quantity
 931,121
 931,121
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > GROUPE GO SPORT SA
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 793,924
 793,923.77
 Pass
2
 Open
 779,076
 779,075.80
 Pass
3
 Total Revenue YTD
 1,573,000
 1,572,999.57
 Pass
4
 Last Year Shipped YTD
 560,244
 560,244.03
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 54,294
 54,294
 Pass
7
 LY Quantity
 40,815
 40,815
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > F AND F
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 260,684
 260,683.88
 Pass
2
 Open
 112,110
 112,110.14
 Pass
3
 Total Revenue YTD
 372,794
 372,794.02
 Pass
4
 Last Year Shipped YTD
 0
 0
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 18,770
 18,770
 Pass
7
 LY Quantity
 0
 0
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: North America > FOOT LOCKER INC - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 1,162,026
 1,162,025.94
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 1,162,026
 1,162,025.94
 Pass
4
 Last Year Shipped YTD
 851,140
 851,139.71
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 101,667
 101,667
 Pass
7
 LY Quantity
 76,280
 76,280
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > MnO International AB - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 221,678
 221,677.50
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 221,678
 221,677.50
 Pass
4
 Last Year Shipped YTD
 854,238
 854,238.13
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 18,694
 18,694
 Pass
7
 LY Quantity
 116,556
 116,556
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > INNOVA SPORT SA DE CV - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 113,745
 113,745.04
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 113,745
 113,745.04
 Pass
4
 Last Year Shipped YTD
 0
 0
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 8,285
 8,285
 Pass
7
 LY Quantity
 0
 0
 Pass
8
 Budget Quantity
 0
 0
 Pass

Silhouette Sub Report Validation

‍Test Conducted

Grouping: North America > 5950
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 31,047,681
 31,047,681.36
 Pass
2
 Open
 41,328,431
 41,328,431.18
 Pass
3
 Total Revenue YTD
 72,376,113
 72,376,112.54
 Pass
4
 Last Year Shipped YTD
 28,811,657
 28,811,657.23
 Pass
5
 Current Year Budget YTD
 77,960,982
 77,960,982
 Pass
6
 TY Quantity
 2,106,764
 2,106,764
 Pass
7
 LY Quantity
 2,304,102
 2,304,102
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > 950
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 2,447,441
 2,447,441.41
 Pass
2
 Open
 6,734,490
 6,734,490.49
 Pass
3
 Total Revenue YTD
 9,181,932
 9,181,931.90
 Pass
4
 Last Year Shipped YTD
 683,575
 683,574.59
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 177,654
 177,654
 Pass
7
 LY Quantity
 49,169
 49,169
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > 950 AFRAME
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 219,290
 219,290.38
 Pass
2
 Open
 547,754
 547,754.05
 Pass
3
 Total Revenue YTD
 767,044
 767,044.43
 Pass
4
 Last Year Shipped YTD
 0
 0
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 14,993
 14,993
 Pass
7
 LY Quantity
 0
 0
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: North America > 3930 - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 5,589,304
 5,589,303.64
 Pass
2
 Open
 1,775
 1,775.21
 Pass
3
 Total Revenue YTD
 5,591,079
 5,591,078.85
 Pass
4
 Last Year Shipped YTD
 3,983,225
 3,983,225.11
 Pass
5
 Current Year Budget YTD
 7,235,165
 7,235,165
 Pass
6
 TY Quantity
 547,081
 547,081
 Pass
7
 LY Quantity
 491,967
 491,967
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > AFRAME TRUCKER - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 268,004
 268,003.87
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 268,004
 268,003.87
 Pass
4
 Last Year Shipped YTD
 303,701
 303,701.34
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 28,785
 28,785
 Pass
7
 LY Quantity
 35,748
 35,748
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > GLOVES - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 122,927
 122,926.90
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 122,927
 122,926.90
 Pass
4
 Last Year Shipped YTD
 0
 0
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 60
 60
 Pass
7
 LY Quantity
 0
 0
 Pass
8
 Budget Quantity
 0
 0
 Pass

Collection Sub Report Validation

‍Test Conducted

Grouping: North America > CUSTOM
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 14,315,104
 37,958,552.87
 Pass
2
 Open
 37,958,553
 37,958,553.02
 Pass
3
 Total Revenue YTD
 52,273,657
 52,273,657.46
 Pass
4
 Last Year Shipped YTD
 10,890,258
 10,890,257.63
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 1,880,401
 1,880,401
 Pass
7
 LY Quantity
 1,490,916
 1,490,916
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > LEAGUE BASIC
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 1,363,401
 1,363,400.82
 Pass
2
 Open
 1,036,872
 1,036,872.42
 Pass
3
 Total Revenue YTD
 2,400,272
 2,400,271.85
 Pass
4
 Last Year Shipped YTD
 546,095
 546,095.36
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 81,768
 81,768
 Pass
7
 LY Quantity
 32,909
 32,909
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > CUSTOM 5950
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 267,696
 267,696.36
 Pass
2
 Open
 197,718
 197,717.64
 Pass
3
 Total Revenue YTD
 465,414
 465,414.40
 Pass
4
 Last Year Shipped YTD
 110,657
 110,656.93
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 17,223
 17,223
 Pass
7
 LY Quantity
 5,671
 5,671
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: North America > AC PERFORMANCE- MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 3,909,500
 3,909,500.23
 Pass
2
 Open
 216,249
 216,249.45
 Pass
3
 Total Revenue YTD
 4,125,749
 4,125,749.12
 Pass
4
 Last Year Shipped YTD
 6,812,110
 6,812,109.63
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 274,329
 274,329
 Pass
7
 LY Quantity
 490,005
 490,005
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: EMEA > HWC TEAM FLIP - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 523,934
 523,934.36
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 523,934
 523,934.36
 Pass
4
 Last Year Shipped YTD
 0
 0
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 30,485
 30,485
 Pass
7
 LY Quantity
 0
 0
 Pass
8
 Budget Quantity
 0
 0
 Pass

Grouping: Emerging Market > CUS 9FIFTY SNAP - MTD
SNo
 Test Case
 Value in CR
 Value in BEx/Budget Sheet
 Pass/Fail Criteria
1
 Current Year Shipped YTD
 44,671
 44,671.31.81
 Pass
2
 Open
 0
 0
 Pass
3
 Total Revenue YTD
 44,671
 44,671.32.81
 Pass
4
 Last Year Shipped YTD
 65,701
 65,700.85.61
 Pass
5
 Current Year Budget YTD
 0
 0
 Pass
6
 TY Quantity
 3,946
 3,946
 Pass
7
 LY Quantity
 3,228
 3,228
 Pass
8
 Budget Quantity
 0
 0
 Pass

‍Reference Document(Specification)

2013-03-15 - 5910.200 - Spec - Contract Reports